<%@ page import="fachada.*,java.util.ArrayList,java.sql.*, conexao.*;" contentType="text/html; charset=UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US" xml:lang="en"-->
<head>

<meta property="og:site_name" content="LocAutoWeb" />
<meta property="og:title" content="Locadora de Veiculos Web" />
<meta property="og:image" content="http://www.locautoweb.com.br/imagem.jpg" />
    
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
    <!-- meta http-equiv="cache-control"   content="no-cache" /-->
    <meta http-equiv="pragma" content="no-cache" />


    <title>::: Loc AutoWeb - Locadora de Veículos Web :::</title>

    <link rel="stylesheet" href="layout/style.css" type="text/css" media="screen" />
    <!--[if IE 6]><link rel="stylesheet" href="style.ie6.css" type="text/css" media="screen" /><![endif]-->
    <!--[if IE 7]><link rel="stylesheet" href="style.ie7.css" type="text/css" media="screen" /><![endif]-->

    <script type="text/javascript" src="script.js"></script>
</head>
<body>
<!-- iframe src="radio/player.html" width="400" marginwidth="0" height="40" marginheight="0" scrolling="no" frameborder="0"></iframe-->
    <div id="art-page-background-gradient"></div>
    <div id="art-page-background-glare">
        <div id="art-page-background-glare-image"></div>
    </div>
    <div id="art-main">
        <div class="art-sheet">
            <div class="art-sheet-tl"></div>
            <div class="art-sheet-tr"></div>
            <div class="art-sheet-bl"></div>
            <div class="art-sheet-br"></div>
            <div class="art-sheet-tc"></div>
            <div class="art-sheet-bc"></div>
            <div class="art-sheet-cl"></div>
            <div class="art-sheet-cr"></div>
            <div class="art-sheet-cc"></div>
            <div class="art-sheet-body">
                <div class="art-nav">
                	<ul class="art-menu">
                		<li>
                			<a href="#" class="active"><span class="l"></span><span class="r"></span><span class="t">Home</span></a>
                		</li>
                		<li>
                			<a href="#"><span class="l"></span><span class="r"></span><span class="t">Cadastre-se</span></a>
                			<ul>
                				<li><a href="TelaCadastroAgencia.jsp">Agência</a> </li>        					               					
                				<li><a href="TelaCadastroUsuario.jsp">Pessoa Física</a></li>
                				
                			</ul>
                		</li>		
                		<li>
                			<a href="menu.jsp"><span class="l"></span><span class="r"></span><span class="t">Módulo Administrativo</span></a>
                		</li>
                		<li>
                			<a href="index_acesso.jsp"><span class="l"></span><span class="r"></span><span class="t">Login</span></a>
                		</li>
                		
                		<li><a href="TelaCadastroComercial.jsp"><span class="l"></span><span class="r"></span><span class="t">&nbsp;&nbsp;&nbsp;Publicar vídeo</span></a></li>
                	</ul>
                	
                	
                </div>
                <div class="art-header">
                    <div class="art-header-jpeg"></div>
                    <script type="text/javascript" src="swfobject.js"></script>
                    <div id="art-flash-area">
                    <div id="art-flash-container">
                    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="900" height="225" id="art-flash-object">
                        <param name="movie" value="images/flash.swf" />
                        <param name="quality" value="high" />
                    	<param name="scale" value="exactfit" />
                    	<param name="wmode" value="transparent" />
                    	<param name="flashvars" value="color1=0xFFFFFF&amp;alpha1=.76&amp;framerate1=24&amp;loop=true" />
                        <param name="swfliveconnect" value="true" />
                        <!--[if !IE]>-->
                        <object type="application/x-shockwave-flash" data="layout/images/flash.swf" width="900" height="225">
                            <param name="quality" value="high" />
                    	    <param name="scale" value="exactfit" />
                    	    <param name="wmode" value="transparent" />
                    	    <param name="flashvars" value="color1=0xFFFFFF&amp;alpha1=.76&amp;framerate1=24&amp;loop=true" />
                            <param name="swfliveconnect" value="true" />
                        <!--<![endif]-->
                          	<div class="art-flash-alt"><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></div>
                        <!--[if !IE]>-->
                        </object>
                        <!--<![endif]-->
                    </object>
                    </div>
                    </div>
                    <script type="text/javascript">swfobject.switchOffAutoHideShow();swfobject.registerObject("art-flash-object", "9.0.0", "expressInstall.swf");</script>
                </div>
                
                <div class="art-content-layout">
                    <div class="art-content-layout-row">
                        <div class="art-layout-cell art-content">
                            <div class="art-post">
                                <div class="art-post-tl"></div>
                                <div class="art-post-tr"></div>
                                <div class="art-post-bl"></div>
                                <div class="art-post-br"></div>
                                <div class="art-post-tc"></div>
                                <div class="art-post-bc"></div>
                                <div class="art-post-cl"></div>
                                <div class="art-post-cr"></div>
                                <div class="art-post-cc"></div>
                                <div class="art-post-body">
                            <div class="art-post-inner art-article">
                                            <h2 class="art-postheader">
                                                <img src="layout/images/postheadericon.png" width="30" height="31" alt="postheadericon" />
                                                Loc AutoWeb
                                            </h2>
                                            
                                            <div class="art-postcontent">
                                                <!-- article-content -->
                                                
                                                
                                                <p>O Loc AutoWEB é uma aplicação WEB destinada a pessoas físicas e agencias que podem assumir papéis de Locadores e Locatários de veículos que 
                                                desejam alugar veículos. Através do site, estes tipos de usuários poderão cadastrar seus bens (veículos) para que estes possam ser consultados
                                                 por clientes interessados (Pessoa Física e Jurídica), os quais poderão visualizar as reais características do item a ser locado, por temporada
                                                  ou por períodos. Os locatários poderão também efetuar buscas por disponibilidade de veículos maneira prática, rápida e eficaz.
                                                	<!-- <span class="art-button-wrapper">
                                                		<span class="l"> </span>
                                                		<span class="r"> </span>
                                                		<a class="art-button" href="javascript:void(0)">Read more...</a>
                                                	</span> -->
                                                	
                           <br /><br /><br />                     	
                           <div id="corpo_texto">
		
		   <div id="corpo" class="texto">
		    <%
				Connection conn = null;
				Statement stmt = null;
				ResultSet rset = null;
				DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
				conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","sa");
				stmt = conn.createStatement();
				rset = stmt.executeQuery("select v.placa, v.ano, v.foto, v.acessorio, v.tarifa, deref(cor).descricao as cor, deref(modelo).descricao as mod from tb_veiculo v where rownum <=6"); 
	
			if (rset != null){
				while (rset.next()) {

	   		%>
	       <center>
			<div style="float:left; width:33%">
 			 <table>
			  <tr><td align="left">
				<img src="displayfoto?placa=<%=rset.getObject("placa")%>" width="238" height="228">
			  </td></tr>
			  <tr><td align="left">
					  Ano: <%=rset.getObject("ano")%><br>
				Acessório: <%=rset.getObject("acessorio")%><br>
					  Cor: <%=rset.getObject("cor")%><br>
				   Modelo: <%=rset.getObject("mod")%><br>
				   Tarifa: R$ <%=rset.getObject("tarifa")%>
			  </td></tr>
			 </table>
			</div>
		   </center>
		   <% } %>
		   <%} else {%>
		   
		   <div id="corpo_texto" >
			<table>
		 	<tr><td>
		   		<div id="corpo" class="texto"></div>
		   	</td></tr>
		   </table>
		   
		   
			<% 	} conn.close();%>
		   </div>
                                        </p>
                                               <div class="cleared"></div>
                                                <div class="art-content-layout overview-table">
                                                  <div class="art-content-layout-row">
                
                                                	<div class="art-layout-cell">
                                                      <div class="overview-table-inner">
                
							                		  <!-- table >
														 <tr><td-->
														  <%
																Connection conn1 = null;
																Statement stmt1 = null;
																ResultSet rs = null;
																DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
																conn1 = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","sa");
																stmt1 = conn1.createStatement();
																rs = stmt1.executeQuery("select codigo, video from tb_video_comercial");
															if (rs != null){
																while (rs.next()) {
												
													   		%>
														   <div id="corpo" class="texto">
														    <object classid="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" id="player" width="300" height="200">
															<param name="url" value="displayvideo?codigo=<%=rs.getObject("codigo")%>" />
															<param name="src" value="displayvideo?codigo=<%=rs.getObject("codigo")%>" />
															<param name="showcontrols" value="true" />
															<param name="autostart" value="false" />
															</object>
														   </div>
														   <%}conn1.close();} %>
														 <!-- /td></tr>
														</table-->
														<div class="cleared"></div>
                                                
                                                		
                                                	
                                                	</div><!-- end row -->
                                                </div><!-- end table -->
                                                    
                                                <!-- /article-content -->
                                            </div>                <div class="cleared"></div>
                            </div>
                            
                            		<div class="cleared"></div>
                                </div>
                            </div>
                           
                        </div>
                    </div>
                </div>
                <div class="cleared"></div><div class="art-footer">
                    <div class="art-footer-t"></div>
                    <div class="art-footer-l"></div>
                    <div class="art-footer-b"></div>
                    <div class="art-footer-r"></div>
                    <div class="art-footer-body">
                         <!-- <a href="#" class="art-rss-tag-icon" title="RSS"></a>
                        <div class="art-footer-text">
                            <p><a href="#">Contact Us</a> | <a href="#">Terms of Use</a> | <a href="#">Trademarks</a>
                                | <a href="#">Privacy Statement</a><br />
                                Copyright &copy; 2010 ---. All Rights Reserved.</p>
                        </div> -->
                         <div id="rodape" class="texto_rodape">
		   <pre><br/><font size="1" face="Arial, Helvetica, sans-serif">Copyright &copy; 2012, <strong>RAJ® Systems</strong>  Recife - PE</font></pre>
<a href="https://twitter.com/share" class="twitter-share-button" data-lang="pt" data-size="large">Tweetar</a>
				<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
		
		
		<div id="fb-root"></div>
			<script>(function(d, s, id) {
					  var js, fjs = d.getElementsByTagName(s)[0];
					  if (d.getElementById(id)) return;
					  js = d.createElement(s); js.id = id;
					  js.src = "//connect.facebook.net/pt_BR/all.js#xfbml=1";
					  fjs.parentNode.insertBefore(js, fjs);
					}(document, 'script', 'facebook-jssdk'));
			</script>

<div class="fb-like" data-href="http://www.locautoweb.com.br" data-send="true" data-width="450" data-show-faces="true"></div>
		
		</div>
		
	</div>    
                		<div class="cleared"></div>
                    </div>
                </div>
        		<div class="cleared"></div>
            </div>
        </div>
            
</body>
</html>
